package com.fsc.mapper;

import com.fsc.entity.domain.AnnRepoNews;
import com.fsc.entity.domain.StudentActivity;
import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.fsc.entity.dto.NewsDTO;
import org.apache.ibatis.annotations.Select;

import java.util.List;

/**
* @author Jensine
* @description 针对表【student_activity(通知、公告、新闻表)】的数据库操作Mapper
* @createDate 2024-06-27 17:08:06
* @Entity com.fsc.entity.domain.StudentActivity
*/
public interface StudentActivityMapper extends BaseMapper<StudentActivity> {
    @Select("SELECT * " +
            "FROM student_activity WHERE school_id = #{schoolId} ")
    List<StudentActivity> getAll(int schoolId);

    @Select("SELECT * " +
            "FROM student_activity WHERE school_id = #{schoolId} AND author_id = #{authorId} ")
    List<StudentActivity> getActivity(int schoolId,int authorId);
}




